﻿using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Data.OleDb;
using System.Linq;
using System.Globalization;
using System.Web.UI.WebControls;
using IGIS.BOL;
using IGIS.Core;
using OSGeo.MapGuide;


namespace IGIS.Extensions
{
    public partial class SearchPolygon : utilityfunctions
    {
          protected void Page_Load(object sender, System.EventArgs e)
        {

            try
            {
                //   mgPolygonID = GetRequestParameters()["ID"];

               // GetPolygonDetails(Convert.ToDecimal(mgPolygonID));
                //FillProjectDetailsUI();
                if (!Page.IsPostBack)
                {
                  //  ClearSessions();
                    FillDropDowns();
                }





            }
            catch (MgException mge)
            {
                // Response.Write(mge.GetExceptionMessage());
                //Response.Write(mge.GetDetails());
            }

        }
          private void FillDropDowns()
          {

              using (HetzEntities db = new HetzEntities())
              {
                 
                  //var query = from p in db.TBL_SearchConfigurator
                  //            orderby p.TableHebName ascending
                  //            select p;
                  //DrpSearchBy.DataSource = query.ToList<LUT_SiteType>();

                  //DrpSearchBy.DataTextField = "Value";
                  //DrpSearchBy.DataValueField = "SiteTypeID";
                  //DrpSearchBy.DataBind();

                  //var queryPriority = from p in db.LUT_Priority
                  //                    orderby p.PriorityID ascending
                  //                    select p;
                  //DrpPriority.DataSource = queryPriority.ToList<LUT_Priority>();
                  //DrpPriority.DataTextField = "Value";
                  //DrpPriority.DataValueField = "PriorityID";
                  //DrpPriority.DataBind();

                  //var queryPrefStatus = from p in db.LUT_PerfStatus
                  //                      orderby p.PrefStatusID ascending
                  //                      select p;
                  //DrpPrefStatus.DataSource = queryPrefStatus.ToList<LUT_PerfStatus>();
                  //DrpPrefStatus.DataTextField = "Value";
                  //DrpPrefStatus.DataValueField = "PrefStatusID";
                  //DrpPrefStatus.DataBind();


                  //var queryCoordinator = from p in db.LUT_Coordinator
                  //                       orderby p.CoordinatorID ascending
                  //                       select p;
                  //DrpCoordinator.DataSource = queryCoordinator.ToList<LUT_Coordinator>();
                  //DrpCoordinator.DataTextField = "Value";
                  //DrpCoordinator.DataValueField = "CoordinatorID";
                  //DrpCoordinator.DataBind();

                  //var queryOrderer = from p in db.LUT_Orderer
                  //                   orderby p.SponsorID ascending
                  //                   select p;
                  //DrpOrderer.DataSource = queryOrderer.ToList<LUT_Orderer>();
                  //DrpOrderer.DataTextField = "SponsorName";
                  //DrpOrderer.DataValueField = "SponsorID";
                  //DrpOrderer.DataBind();


                  //var querySponsor = from p in db.LUT_sponser
                  //                   orderby p.SponsorID ascending
                  //                   select p;
                  //DrpSponsor.DataSource = querySponsor.ToList<LUT_sponser>();
                  //DrpSponsor.DataTextField = "SponsorName";
                  //DrpSponsor.DataValueField = "SponsorID";
                  //DrpSponsor.DataBind();
                  //db.LU
                  //  drpSiteTypes.DataSource = 

              }
          }

        
    }

}